﻿CREATE PROCEDURE [dbo].[LogCheckIntervalLastCheckUpdate]
	@InstanceName NVARCHAR(255),
	@LogType      NVARCHAR(255)
AS
BEGIN
UPDATE [dbo].LogCheckIntervalConfig
SET   LastCheck = GETDATE()
WHERE Id = (SELECT L.Id
            FROM       [dbo].[InstanceConfig]          I
            INNER JOIN [dbo].[LogCheckIntervalConfig]  L ON I.Id = L.InstanceConfigId
            WHERE I.InstanceName = @InstanceName AND L.LogType = @LogType)
END